/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.action.red;

import com.mapping.Empleado;
import com.mapping.Red;
import com.opensymphony.xwork2.ActionSupport;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;
import javax.persistence.TypedQuery;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.Result;

/**
 *
 * @author Ricardo
 */
@Namespace(value = "/")
@Action(value = "gestionRed", results = {
    @Result(name = "success", location = "/GestionRed/gestionRed.jsp")})
public class GestionRed extends ActionSupport{
    private List<Empleado> redes;
    
    @Override
    public String execute() {        
        EntityManagerFactory emf = Persistence.createEntityManagerFactory("inventarios");
        EntityManager em = emf.createEntityManager();
        EntityTransaction tx = em.getTransaction();
        tx.begin();
        
        TypedQuery  e=em.createQuery("SELECT r FROM Red r", Red.class);
        redes= e.getResultList();                        
        em.flush();
        tx.commit();
        em.close();     
        return SUCCESS;
    }

    public List<Empleado> getRedes() {
        return redes;
    }
        
}
